SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tms_band_product
-- ----------------------------
DROP TABLE IF EXISTS `tms_band_product`;
CREATE TABLE `tms_band_product` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `band_code` varchar(64) NOT NULL COMMENT 'Band Code',
  `product_code` varchar(64) NOT NULL COMMENT '产品信息 Code',
  `amount` decimal(10,2) NOT NULL COMMENT '关联金额',
  `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  `tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `uk_band_code` (`band_code`) USING BTREE,
  UNIQUE KEY `uk_product_code` (`product_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Band 与产品关联';

-- ----------------------------
-- Records of tms_band_product
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;